The following example uses the HasOpenDesigner property to return whether or not the specified component, in this case a form, of a particular project has an open designer.
Debug.Print Application.VBE.VBProjects(1).VBComponents(1).HasOpenDesigner